package com.jy.adscm.spss.mapper.mysql;


import java.util.List;

import com.baomidou.mybatisplus.mapper.BaseMapper;

import com.jy.adscm.spss.bean.Yl_Material;
import com.jy.adscm.spss.bean.Yl_Materialdetail;
import com.jy.adscm.spss.bean.Yl_MaterialdetailQuery;
import org.apache.ibatis.annotations.Param;

public interface Yl_MaterialdetailMapper extends BaseMapper<Yl_Material> {
	int countByExample(Yl_MaterialdetailQuery example);

	int deleteByExample(Yl_MaterialdetailQuery example);

	int deleteByPrimaryKey(String did);



	int insertSelective(Yl_Material record);

	List<Yl_Materialdetail> selectByExample(Yl_MaterialdetailQuery example);

	Yl_Material selectByPrimaryKey(String did);

	int updateByExampleSelective(@Param("record") Yl_Material record, @Param("example") Yl_MaterialdetailQuery example);

	int updateByExample(@Param("record") Yl_Material record, @Param("example") Yl_MaterialdetailQuery example);

	int updateByPrimaryKeySelective(Yl_Material record);

	int updateByPrimaryKey(Yl_Material record);
	/**
	 * 获取主菜单的实际数量于已经发货的数量差值
	 * @return
	 */
	List<Yl_Material> getYlkDiff(@Param("resourceName") String resourceName);
	/**
	 * 获取子菜单的详细信息 
	 * @return
	 */
	List<Yl_Materialdetail> getYlkDetail(@Param("resourceName") String resourceName);
}